# Prerequisites

Before you can use Microsoft SQL Server as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

## Client

Microsoft SQL Server Native Client must be installed on the Qlik Compose machine.

## Permissions

To use Microsoft SQL Server as a Data Warehouse a Qlik Compose project, the Compose user must be granted the following privileges in the Microsoft SQL Server database:

* The Qlik Compose user must have at least the `db_owner` user role on the Microsoft SQL Server database.
* The Qlik Compose user must be granted the CREATE VIEW permission on the Microsoft SQL Server database.
* A Microsoft SQL Server system administrator must provide this permission for all Qlik Compose users.